package com.trkj.dao.lzs;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Salary;
import com.trkj.pojo.SalaryAccount;

public interface SalaryAccountDao  extends  CrudRepository<SalaryAccount, Long> {	
   /*  @Query("from SalaryAccount e where e.accountName like ?1")
     public  List<SalaryAccount>queryByName(String name);	*/

     @Query("from SalaryAccount s where s.accountName like ?1")
     public  List<SalaryAccount>queryByName(String text);	
     
     @Query("from SalaryAccount e")
 	public List<SalaryAccount> queryByPage(Pageable p);
     
     
     @Query("SELECT s,p FROM SalaryAccount s inner join s.projectTemplate p")
 	public List<Object[]> find_pay();

	

}
